INVBILLING010 (BILLING_UPDATE_EXTRACT_ON_ENTITY_UPDATE)

N4 uses this setting to determine which Unit entity fields to update in the extracted records in the Chargeable Unit Events view (on page 1) each time you update the underlying unit or unit facility visit (UFV). By default, N4 updates all the Unit entity fields that are included in the extracted records.

You can use an XML mapping file (UnitExtractMap.xml) to prevent N4 from updating certain Unit entity fields in the extracted records when you update the underlying unit or UFV. To create this mapping file, you can use any text/XML editor of your choice. See below for a Sample UnitExtractMap.xml file.

Each entity field included in the file has an update attribute. If this attribute is set as true for a field, N4 updates that field in the extracted records when you update the underlying unit or UFV. If this attribute is set as false for a field, N4 does not update that field in the extracted records.

By default, the update attribute is set to true for all the fields in the UnitExtractMap.xml file, as shown in the code segment below:

<field id="bexuCategory" update="true" description="Category"/>

For more information on how to override the INVBILLING010 setting, see Prevent updates to the records in the Chargeable Unit Events view (on page 1).

See also, INVBILLING014 (BILLING_UPDATE_EXTRACT_FLEX_ON_ENTITY_UPDATE_FLEX) (on page 1).

Notes

• In the UnitExtractMap.xml file you can specify only the fields related to the Unit entity. You cannot specify fields related to any other entity.

• You must set the update attribute in the bexuObVisitId field to false when you reroute the containers from one vessel to another. For more information, see Prevent updating chargeable unit events on rerouting containers to another vessel (on page 1).

• N4 updates a record only if the status for the extracted record is QUEUED.

• To update the I/B Carrier ATD and the Time Discharge Complete fields, you must use the ARGOCUE001 (UPDATE_INBOUND_UFV _CUE_FOR_DEPARTED_VESSEL)andARGOCUE002 (UPDATE_INBOUND_UFV_CUE_FOR_DEPARTED_TRAIN) settings.

• If the update attribute in the bexuCargoQuantity field is set to true, N4 does not update the non-time based Chargeable Unit Events (for example, storage and reefer related events). Also, once the CUEs are extracted for a cargo lot, N4 displays the Cargo Quantity Update for CUEs field in the Adjust Cargo Lot Quantity form with the list of CUEs for the selected cargo lot.

Sample UnitExtractMap.xml file

<?xml version="1.0" encoding="UTF-8"?>

<unit-extract-mappings>

    <unit-fields>

        <!--unit-fields-->

        <field id="bexuUnitGkey" update="true" description="Unit Gkey"/>

        <field id="bexuCategory" update="true" description="Category"/>

        <field id="bexuDrayStatus" update="true" description="Dray Status"/>

        <field id="bexuFreightKind" update="true" description="Freight Kind"/>

        <field id="bexuCargoQuantity" update="true" description="Cargo quantity"/>

        <field id="bexuCargoQuantityUnit" update="true" description="Cargo quantity unit"/>

        <field id="bexuIsOog" update="true" description="Is Oog"/>

        <field id="bexuIsRefrigerated" update="true" description="Is Refrigerated"/>

        <field id="bexuIsHazardous" update="true" description="Is Hazardous"/>

        <field id="bexuEqOwnerId" update="true" description="Equipment owner Id"/>

        <field id="bexuLineOperatorId" update="true" description="Line Operator Id"/>

        <field id="bexuBookingNbr" update="true" description="Booking Nbr"/>

        <!--setUnitEquipmentFields-->

        <field id="bexuEqId" update="true" description="Equipment Id"/>

        <field id="bexuIsoCode" update="true" description="Iso Code"/>

        <field id="bexuIsoGroup" update="true" description="Iso Group"/>

        <field id="bexuEqSubClass" update="true" description="Equipment Sub Class"/>

        <field id="bexuIsoLength" update="true" description="Iso Length"/>

        <field id="bexuIsoHeight" update="true" description="Iso Height"/>

        <!--setUnitRoutingFields-->

        <routing-fields>

            <field id="bexuPod1" update="true" description="Pod1"/>

            <field id="bexuPol1" update="true" description="The port at which the container was loaded or will be loaded on a vessel"/>

            <field id="bexuOpl" update="true" description="Optioinal port of load"/>

        </routing-fields>

        <!--setGoodsFields-->

        <goods-fields>

            <field id="bexuFinalDestination" update="true" description="Final Destinatioin"/>

            <field id="bexuTempRequiredC" update="true" description="Temp Required C"/>

            <field id="bexuConsigneeId" update="true" description="Consignee Id"/>

            <field id="bexuShipperId" update="true" description="Shipper Id"/>

            <field id="bexuBlNbr" update="true" description="BL Number"/>

            <field id="bexuCommodityId" update="true" description="Commodity Id"/>

            <field id="bexuImdgClass" update="true" description="Imdg Class"/>

            <field id="bexuFireCode" update="true" description="Fire Code"/>

            <field id="bexuFireCodeClass" update="true" description="Fire Code Class"/>

            <field id="bexuIsHazardous" update="true" description="Is Hazardous"/>

        </goods-fields>

    </unit-fields>

    <unit-visit-fields>

        <field id="bexuUfvTimeIn" update="true" description="Visit Time In"/>

        <field id="bexuUfvTimeOut" update="true" description="Visit Time Out"/>

        <field id="bexuGuaranteeThruDay" update="true" description="GuaranteeThruDay"/>

        <field id="bexuGuaranteeParty" update="true" description="Guarantee Party"/>

        <field id="bexuEventEndTime" update="true" description="End time of the event. It is applicale like STORAGE,REEFER kind"/>

        <field id="bexuTimeOfLoading" update="true" description="Time Of Loading"/>

        <field id="bexuRestowReason" update="true" description="Restow Reason"/>

        <field id="bexuRestowType" update="true" description="Restow Type"/>

        <!--setInBoundDetails-->

        <inbound-fields>

            <field id="bexuIbId" update="true" description="Inbound Id"/>

            <field id="bexuIbLocType" update="true" description="Inbound Location Type"/>

            <field id="bexuIbVesselClassId" update="true" description="Inbound vessel class Id. Applicable for vessel"/>

            <field id="bexuIbServiceId" update="true" description="Inbound service Id. Applicable for vessel"/>

            <field id="bexuIbVesselType" update="true" description="IInbound vessel type RORO, PSNGR etc.,"/>

            <field id="bexuIbCarrierETA" update="true" description="Intended inbound carrier ETA"/>

            <field id="bexuIbCarrierName" update="true" description="Intended inbound carrier name"/>

            <field id="bexuIbCallNbr" update="true" description="Intended inbound carrier call nbr"/>

            <field id="bexuIbVisitId" update="true" description="Inbound carrier visit id"/>

            <field id="bexuIbCarrierLineId" update="true" description="Inbound carrier line id"/>

            <field id="bexuFirstAvailability" update="true" description="Inbound First Availability Date"/>

            <field id="bexuTimeDischargeComplete" update="true" description="Time discharge of entire inbound carrier visit completed"/>

            <field id="bexuTimeFirstFreeDay" update="true" description="Time First Free Day"/>

        </inbound-fields>

        <!--setIntendedInBoundDetails-->

        <intended-inbound-fields>

            <field id="bexuIbintendedId" update="true" description="The intended inbound carrier id"/>

            <field id="bexuIbintendedVesselClassId" update="true" description="Intended inbound vessel class Id. Applicable for vessel"/>

            <field id="bexuIbintendedServiceId" update="true" description="Intended inbound service Id. Applicable for vessel"/>

            <field id="bexuIbintendedVesselType" update="true" description="Intended inbound vessel type RORO, PSNGR etc.,"/>

            <field id="bexuIbintendedCarrierETA" update="true" description="Intended inbound carrier ETA"/>

            <field id="bexuIbintendedCarrierName" update="true" description="Intended inbound carrier name"/>

            <field id="bexuIbintendedCallNbr" update="true" description="Intended inbound carrier call nbr"/>

            <field id="bexuIbintendedVisitId" update="true" description="Intended inbound carrier visit id"/>

            <field id="bexuIbintendedCarrierLineId" update="true" description="Intended inbound carrier line id"/>

            <field id="bexuFirstAvailability" update="true" description="Intended Intended inbound First Availability Date"/>

            <field id="bexuTimeDischargeComplete" update="true" description="Time discharge of entire intended inbound carrier visit completed"/>

            <field id="bexuTimeFirstFreeDay" update="true" description="Time First Free Day"/>

        </intended-inbound-fields>

        <!--setOutBoundDetails-->

        <outbound-fields>

            <field id="bexuObVesselClassId" update="true" description="Outbound Vessel Class Id"/>

            <field id="bexuObServiceId" update="true" description="Outbound Service Id"/>

            <field id="bexuObVesselType" update="true" description="Outbound Vessel Type"/>

            <field id="bexuObCarrierETA" update="true" description="Outbound Carrier Eta"/>

            <field id="bexuObCarrierATA" update="true" description="Outbound Carrier Ata"/>

            <field id="bexuObCarrierATD" update="true" description="Outbound Carrier Atd"/>

            <field id="bexuObCarrierName" update="true" description="Outbound Carrier Name"/>

            <field id="bexuObCallNbr" update="true" description="Outbound Call Nbr"/>

            <field id="bexuObVisitId" update="true" description="Outbound Visit Id"/>

            <field id="bexuObCarrierLineId" update="true" description="Outbound Carrier Line Id"/>

        </outbound-fields>

        <!--setIntendedOutBoundDetails-->

        <intended-outbound-fields>

            <field id="bexuObintendedId" update="true" description="Outbound Intended Id"/>

            <field id="bexuObintendedVesselClassId" update="true" description="Outbound Intended Vessel Class Id"/>

            <field id="bexuObintendedServiceId" update="true" description="Outbound Intended Service Id"/>

            <field id="bexuObintendedVesselType" update="true" description="Outbound Intended Vessel Type"/>

            <field id="bexuObintendedCarrierETA" update="true" description="Outbound Intended Carrier Eta"/>

            <field id="bexuObintendedCarrierATA" update="true" description="Outbound Intended Carrier Ata"/>

            <field id="bexuObintendedCarrierATD" update="true" description="Outbound Intended Carrier Atd"/>

            <field id="bexuObintendedCarrierName" update="true" description="Outbound Intended"/>

            <field id="bexuObintendedCallNbr" update="true" description="Outbound Intended Carrier Name"/>

            <field id="bexuObintendedVisitId" update="true" description="Outbound Intended Visit Id"/>

            <field id="bexuObintendedCarrierLineId" update="true" description="Outbound Intended Carrier Line Id"/>

        </intended-outbound-fields>

    </unit-visit-fields>

    <lineoperator-fields>

        <field id="bexuLineOperatorId" update="true" description="Line Operator Id"/>

        <field id="bexuObCarrierLineId" update="true" description="Outbound Carrier Line Id"/>

        <field id="bexuIbCarrierLineId" update="true" description="Inbound Carrier Line Id"/>

    </lineoperator-fields>

</unit-extract-mappings>